package com.example.demo.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.demo.pojo.entity.QuestionBank;
import com.example.demo.pojo.entity.QuestionFile;
import com.example.demo.pojo.entity.QuestionLabel;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.SelectKey;

import java.util.List;

@Mapper
public interface QuestionFileMapper extends BaseMapper<QuestionFile> {
    //根据某一学科进行查找
    @Select("select question_id from test.question_file where file_id=#{fileId}")
    List<Integer> searchQuestionBankByRootId(int fileId);


    //测试
    @Select("select * from test.question_file")
    List<QuestionFile>initQuestionFile();
}
